UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XMgUJfO2R8ApbaKkgIHWS7aN1aGbrLagiv20EntZ+PI='
WHERE
key_id = '2a1b16c8f740a902552efb1d82b42f697dde1bcc1f8db410d4d73704dee97fb1'
AND (
token = 'XMgUJfO2R8ApbaKkgIHWS7aN1aGbrLagiv20EntZ+PI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)