UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YjIeZgtnSIokq4We4EajEbHwBgxsoJfKS2Tgqmi5vZ8='
WHERE
key_id = 'c63e20f6a180de25e3b91004d73bee98127e4f6432d5ea3a55b7ee2f6ea29836'
AND (
token = 'YjIeZgtnSIokq4We4EajEbHwBgxsoJfKS2Tgqmi5vZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)