UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '94Wx6r7QhPLSCPvr35JcsOz0xbPgo92G20FGfsRCcyw='
WHERE
key_id = 'bf3bd1c2bb822171806933202f5a8ce23bf7b98caa48b6087856defe35f53e5a'
AND (
token = '94Wx6r7QhPLSCPvr35JcsOz0xbPgo92G20FGfsRCcyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)