UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zhqkZj3XrLPYLg0wFwF6tdtWFe5DOt8G7D8g6bYHJR8='
WHERE
key_id = '640c5d18a9f5077d561f8e93aa555e4793721d9e1cbaeeea0e1207679979c431'
AND (
token = 'zhqkZj3XrLPYLg0wFwF6tdtWFe5DOt8G7D8g6bYHJR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)