UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S5dvk+vqZK59d46Im7dpAs/Ws+yMmRqThpdX29jhAV8='
WHERE
key_id = '1e119614d1964002979f4a06836f921ed2a5f782e7c4e1ffa6cf30962a954ef0'
AND (
token = 'S5dvk+vqZK59d46Im7dpAs/Ws+yMmRqThpdX29jhAV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)