UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BNrPgISPxw62b5p6dhgqzgn7VJaM5x27DDmFrJWqEik='
WHERE
key_id = '5149f59d8b35cd3218bb20d78b650ba9d87638dfbd2f6c98460999e965097ad8'
AND (
token = 'BNrPgISPxw62b5p6dhgqzgn7VJaM5x27DDmFrJWqEik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)