UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bD0YDMvf6GAyEUOT9YtUIAkbDazNwMPGkxkHH8immUE='
WHERE
key_id = '6ef6adba7475ca3b4edec6ad410d44ffdd301e4330b5b1f54d55a9bbde188b8e'
AND (
token = 'bD0YDMvf6GAyEUOT9YtUIAkbDazNwMPGkxkHH8immUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)