UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TKzlH5nMzOvf5rxgML1K4rJicUPjCqCFO09ASfwuQTw='
WHERE
key_id = '278029f24b793acf4b1ef85e36c05e7306fe8379e59f6665d3e925861db96b9f'
AND (
token = 'TKzlH5nMzOvf5rxgML1K4rJicUPjCqCFO09ASfwuQTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)