UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HapuhqAg7YOGb0Ip4mdDAP7wgOiG3gW5ZD1Vq/troP8='
WHERE
key_id = '94b7e42d416d0ccfe2c3b29a0b6f295edaa0a4edf70e756d7f020f2b803d5fc7'
AND (
token = 'HapuhqAg7YOGb0Ip4mdDAP7wgOiG3gW5ZD1Vq/troP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)