UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KuBvrnQQMAJn9d3/EFrca7uOICMgpSjvcb7Zh9yuNjk='
WHERE
key_id = '5889fdf8f86e109a32bbee57b062a90c6a55696b733592662c0bd23aa6897345'
AND (
token = 'KuBvrnQQMAJn9d3/EFrca7uOICMgpSjvcb7Zh9yuNjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)