UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2G+4KtJpU5G8EIb9vPx4zRV5B0qQ7F+4FU2CrKPjvr8='
WHERE
key_id = '0a04b8242644642e5c1001e54dfdac96524ebd7ded5c77bbe14925ba2000223c'
AND (
token = '2G+4KtJpU5G8EIb9vPx4zRV5B0qQ7F+4FU2CrKPjvr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)