UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PYvX4kYkHJ4wG6rMQtCX97uSVCcmY3iv6AZy680hvKk='
WHERE
key_id = '71ebaebd9fd14bd9f238a511995e9a453f71499af075a7b432e43e92ae6a7d9b'
AND (
token = 'PYvX4kYkHJ4wG6rMQtCX97uSVCcmY3iv6AZy680hvKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)