UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hRVJf/avYlbBkmbFn3XxlTNcCQzTp7YKdEI22vTp6O8='
WHERE
key_id = 'acdeb9ccfbbf802199b28528e1f9775aa0be99085f6bea8c84693907451d1742'
AND (
token = 'hRVJf/avYlbBkmbFn3XxlTNcCQzTp7YKdEI22vTp6O8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)