UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XWuqf6lJU4XzmI0fKogk/v/qfGgRRcAuDqVIccbyDs='
WHERE
key_id = '8abc8257ca8250e6546fbef090ff220319e5a36bcdf3de31f0bbbc7968556d84'
AND (
token = '4XWuqf6lJU4XzmI0fKogk/v/qfGgRRcAuDqVIccbyDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)