UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cLPJZmbBWn3dxlKpv+l65xj6lba7zi5Xo/DjZVK4u5Y='
WHERE
key_id = 'be29aa7141af2a1b408b83c8fa2437949eb7f6dfb0dcaa21ffef9183ced65554'
AND (
token = 'cLPJZmbBWn3dxlKpv+l65xj6lba7zi5Xo/DjZVK4u5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)