UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Redf9nAn0GAjKYWT96uCMB5zfj3IQEUuCXAVpd96Ot8='
WHERE
key_id = '894ca4e9e19c8c4410a91f0e89b5bc2bc705e4e05e18ae3b82602b6a41564ff5'
AND (
token = 'Redf9nAn0GAjKYWT96uCMB5zfj3IQEUuCXAVpd96Ot8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)