UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UjW08Li03JRKcReVOmqKuwghm8OKC7M+mjAIbksMLs='
WHERE
key_id = '8119c08b3e5fce0b1ed6fafc8d3927ce0c781311dd9119d4c43b5a7d5c9831ad'
AND (
token = '7UjW08Li03JRKcReVOmqKuwghm8OKC7M+mjAIbksMLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)