UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zw8iPOwKrMpFvLiAqw93so4obngbspWOQpnqECCAKIQ='
WHERE
key_id = '3bc197f0490933531b2e3e5ed303d7c62e81d9e45b24321e5f5f16825e1e0617'
AND (
token = 'Zw8iPOwKrMpFvLiAqw93so4obngbspWOQpnqECCAKIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)