UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mGmnubOt+I/dQ/4lSnSdQb6ROi3pOVjoVZD2TFhG2zo='
WHERE
key_id = '3c0cf5a27bc4a0cb8c86b8b5b8e6572c504204251553d702809b9707b2adb753'
AND (
token = 'mGmnubOt+I/dQ/4lSnSdQb6ROi3pOVjoVZD2TFhG2zo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)