UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '96FRhGaAD5K+yCuUdoGLdWt+AwtT6sqd1dhjPsKMf6k='
WHERE
key_id = '5efbee2559546d6cddd4ba0a42347600e2b0ca5d5a872e486487ed9150cad92a'
AND (
token = '96FRhGaAD5K+yCuUdoGLdWt+AwtT6sqd1dhjPsKMf6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)