UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RiyAkV4gvDmy61M2BoBd/9qyHIbO/zPWwQKMLr+9Isw='
WHERE
key_id = '047973fb5c144e99d969100e0d27f2202f840888eae8e4e6a59612edd9b8b54e'
AND (
token = 'RiyAkV4gvDmy61M2BoBd/9qyHIbO/zPWwQKMLr+9Isw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)