UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dM4KPniZ9xLVUispaTXa8olTC9tukNbNjxZpC5wqBnE='
WHERE
key_id = 'e38c02141e6a6a908db30616e3553e2fa52949a5172cb28f0ca448922d4a38dc'
AND (
token = 'dM4KPniZ9xLVUispaTXa8olTC9tukNbNjxZpC5wqBnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)