UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9BrV3hrWm0mLy8AYxKB+wNddYvMm6/JVExAYHrB37U='
WHERE
key_id = 'd9d3a2d7b4e93840ddcd79b3a6bf0e6de63aa07da5f5c4ae5863f66968c6cadd'
AND (
token = 'L9BrV3hrWm0mLy8AYxKB+wNddYvMm6/JVExAYHrB37U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)