UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hiKx6rnBljjbethXK+VoXJxqD8K6/G0gy/Tqf9OH6ZU='
WHERE
key_id = 'cc58eef9ad092a835fef370e3e47d07ba11c3b4c61f3e4928d629183c22c6e58'
AND (
token = 'hiKx6rnBljjbethXK+VoXJxqD8K6/G0gy/Tqf9OH6ZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)