UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xpyjhBoHN87ViGkh+DrciQMEUyU1c2DMIeljJ7xS/b8='
WHERE
key_id = 'b29cd37d2269c0cef17580344d79b2e297db3beb0d22690bf4a3cd0fbf660d0e'
AND (
token = 'xpyjhBoHN87ViGkh+DrciQMEUyU1c2DMIeljJ7xS/b8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)