UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7IVqMzTzpv00aqvAmRgAlCjnZzrMiQW/jp5lqtor7zs='
WHERE
key_id = '3967da6180f1284c58b0b413557ed8fffba70b5b90b8f416db37e06f2837a5b0'
AND (
token = '7IVqMzTzpv00aqvAmRgAlCjnZzrMiQW/jp5lqtor7zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)