UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DDK7D0xwCTs5LYk6IoHGeilh2cvrk/2kvd4e5It+apw='
WHERE
key_id = '1fcfeee9534e84697626a825aa0df50c2eec238be028b4e459693dc3fd070813'
AND (
token = 'DDK7D0xwCTs5LYk6IoHGeilh2cvrk/2kvd4e5It+apw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)