UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '66XGjAUyVIazNAV2jxur9T3hJXaX88ICRnVW0G8V250='
WHERE
key_id = 'db78f3ce6a2bf6f521f5e65ffcb2ef0c4d1bad45c8d0c44227c8acc148febfe3'
AND (
token = '66XGjAUyVIazNAV2jxur9T3hJXaX88ICRnVW0G8V250='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)