UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oBIIiKBxi3d1J6G8oN2fvRcVRLzI9f20Ugwh9L9uZOw='
WHERE
key_id = '0caeeddd47cf33b776db4f03dcafa6ab92660966a2bf8cc746c86551832561ea'
AND (
token = 'oBIIiKBxi3d1J6G8oN2fvRcVRLzI9f20Ugwh9L9uZOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)