UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o02LCMwaXxgg2kgonKJuEvGuWHQiDZUIxqgkhskddi8='
WHERE
key_id = '7d46ab747a2a1f00abb82ce7ec32402f7237031f3439505ee01d1771a6fd7e78'
AND (
token = 'o02LCMwaXxgg2kgonKJuEvGuWHQiDZUIxqgkhskddi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)