UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mITRIfbZRz63hBjnO7HJcqp+mK1D1Wjw0fV/rg4vrTw='
WHERE
key_id = 'e2f834a4a6c8846088f23a23af4c1dc5304597b12d8356de663b52abb80a530d'
AND (
token = 'mITRIfbZRz63hBjnO7HJcqp+mK1D1Wjw0fV/rg4vrTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)