UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9sfzYNHo5JnDIvPVdZ2RpnXRE6U51362TkRpDMAvU8='
WHERE
key_id = 'd8a9a28f82d11ce899ebee17f8c429f0872fc111e2227533424744d4d9ed890b'
AND (
token = 'X9sfzYNHo5JnDIvPVdZ2RpnXRE6U51362TkRpDMAvU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)