UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2868dv+A3gElCdcBHwoVcR7OpYtlTN7kc7H4yNVLzug='
WHERE
key_id = '6b54553bb09c198e983230ea99148556849538433dde1178706317fb93ca7ff4'
AND (
token = '2868dv+A3gElCdcBHwoVcR7OpYtlTN7kc7H4yNVLzug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)