UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8U0lXmHO8TaLfkGjuzTuyNEgP08zpHfxumGX4uzKrY='
WHERE
key_id = '07c4e2996858f1a9215735fd92dc778d4302972b8db0147cda2a660c6a6777e5'
AND (
token = 'X8U0lXmHO8TaLfkGjuzTuyNEgP08zpHfxumGX4uzKrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)