UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '44gISCQYj5A5kNqN5xlWNpJFh8tmH0xKXgOQUK2QjTM='
WHERE
key_id = '3178e49f4be6547a00ffedd43571f2ff2521cdb30e5a2ca7c5d441d408741acb'
AND (
token = '44gISCQYj5A5kNqN5xlWNpJFh8tmH0xKXgOQUK2QjTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)