UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8W4lbeZj1J5rliEmyAOvpJpOEogjuF1YD3o/XkEFEIU='
WHERE
key_id = '559a93bb59cda26e3bf502ce398327531e4503eb47e822547c8349dfea0f01fd'
AND (
token = '8W4lbeZj1J5rliEmyAOvpJpOEogjuF1YD3o/XkEFEIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)